Our Store database will include the following data:
Field Name Field Type Field Descrpt Field Width Trans Counter Transaction Number Predefined ItemNo Text Item Number 4 SDate Date/Time Date Of Purchase Predefined Descript Text Item Description 25 Dept Text Department Making Sale 8 Qnty Number Quantity Predefined Price Currency Item Price Predefined Sale Yes/No Is Item On Sale? Predefined
Now on to creating the table!
Click
Click Design View
Click
Now you try it!